/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.oa.action.humanresources;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.oa.mapper.humanresources.InterviewInfoMapper;
public class InterviewInfoAction extends BaseAction
{
    @Autowired(required=false)
	private InterviewInfoMapper mapper;
    /**
    招聘信息列表
    */
    
    public Map recruitmentInformation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_hire=mapper.s_hire(params,pagination);
        s_hire.setPagedListInfo(pagination);
        result.put("s_hire", s_hire);
        
        return result;
    }
    /**
    投简人员列表
    */
    
    public Map reductionPerson() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_p=mapper.s_p(params,pagination);
        s_p.setPagedListInfo(pagination);
        result.put("s_p", s_p);
        
        return result;
    }
    /**
    明细页面
    */
    
    public Map detReduction() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> l_pf=mapper.l_pf(params);
        result.put("l_pf", l_pf);
        
        
        SQLList<SQLMap> l_pt=mapper.l_pt(params);
        result.put("l_pt", l_pt);
        
        
        SQLList<SQLMap> l_station=mapper.l_station(params);
        result.put("l_station", l_station);
        
        
        SQLList<SQLMap> s_person=mapper.s_person(params);
        SQLMap s_person_emt=s_person.getExistfirst();
        result.put("s_person", s_person_emt);
        
        
        SQLList<SQLMap> s_level=mapper.s_level(params);
        result.put("s_level", s_level);
        
        
        SQLList<SQLMap> s_wkundergo=mapper.s_wkundergo(params);
        result.put("s_wkundergo", s_wkundergo);
        
        
        SQLList<SQLMap> s_skill=mapper.s_skill(params);
        SQLMap s_skill_emt=s_skill.getExistfirst();
        result.put("s_skill", s_skill_emt);
        
        
        SQLList<SQLMap> s_relation=mapper.s_relation(params);
        result.put("s_relation", s_relation);
        
        
        SQLList<SQLMap> s_mem=mapper.s_mem(params);
        result.put("s_mem", s_mem);
        
        
        
        return result;
    }
    /**
    面试人员列表
    */
    
    public Map interviewerList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_int=mapper.s_int(params,pagination);
        s_int.setPagedListInfo(pagination);
        result.put("s_int", s_int);
        
        return result;
    }
    /**
    明细页面
    */
    
    public Map detInterviewer() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> l_pf=mapper.l_pf(params);
        result.put("l_pf", l_pf);
        
        
        SQLList<SQLMap> l_pt=mapper.l_pt(params);
        result.put("l_pt", l_pt);
        
        
        SQLList<SQLMap> l_station=mapper.l_station(params);
        result.put("l_station", l_station);
        
        
        SQLList<SQLMap> s_person=mapper.s_person(params);
        SQLMap s_person_emt=s_person.getExistfirst();
        result.put("s_person", s_person_emt);
        
        
        SQLList<SQLMap> s_level=mapper.s_level(params);
        result.put("s_level", s_level);
        
        
        SQLList<SQLMap> s_wkundergo=mapper.s_wkundergo(params);
        result.put("s_wkundergo", s_wkundergo);
        
        
        SQLList<SQLMap> s_skill=mapper.s_skill(params);
        SQLMap s_skill_emt=s_skill.getExistfirst();
        result.put("s_skill", s_skill_emt);
        
        
        SQLList<SQLMap> s_relation=mapper.s_relation(params);
        result.put("s_relation", s_relation);
        
        
        SQLList<SQLMap> s_mem=mapper.s_mem(params);
        result.put("s_mem", s_mem);
        
        
        
        return result;
    }
    /**
    修改岗位信息
    */
    
    public Map revisionPost() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_hire=mapper.t_hire(params);
        SQLMap t_hire_emt=t_hire.getExistfirst();
        result.put("t_hire", t_hire_emt);
        
        return result;
    }
    /**
    选择岗位
    */
    
    public Map choicePost() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        TreeBean tb;
        
        SQLList<SQLMap> s_role=mapper.s_role(params,pagination);
        s_role.setPagedListInfo(pagination);
        result.put("s_role", s_role);
        
        
        
        
        
        
        
        
        tb = createTreeBean("l_firm_treecols");
        SQLList<SQLMap> l_firm=mapper.l_firm(params);
        l_firm = l_firm.buildTree(tb,tb.getPid());
        result.put("l_firm", l_firm);
        
        return result;
    }
    /**
    招聘信息详情
    */
    
    public Map detsRecruitment() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_hire=mapper.t_hire(params);
        SQLMap t_hire_emt=t_hire.getExistfirst();
        result.put("t_hire", t_hire_emt);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        
        SQLList<SQLMap> s_jobduty=mapper.s_jobduty(params);
        result.put("s_jobduty", s_jobduty);
        
        return result;
    }
    /**
    选择任职(岗位)要求
    */
    
    public Map choiceJobRequirement() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_jobduty=mapper.p_jobduty(params,pagination);
        p_jobduty.setPagedListInfo(pagination);
        result.put("p_jobduty", p_jobduty);
        
        return result;
    }
    /**
    修改任职岗位要求
    */
    
    public Map upJobRequirement() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_duty=mapper.t_duty(params);
        SQLMap t_duty_emt=t_duty.getExistfirst();
        result.put("t_duty", t_duty_emt);
        
        return result;
    }
    /**
    选择职责要求
    */
    
    public Map choiceResponsibilities() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_duty=mapper.p_duty(params,pagination);
        p_duty.setPagedListInfo(pagination);
        result.put("p_duty", p_duty);
        
        return result;
    }
    /**
    修改职责要求
    */
    
    public Map upResponsibilities() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_jobduty=mapper.t_jobduty(params);
        SQLMap t_jobduty_emt=t_jobduty.getExistfirst();
        result.put("t_jobduty", t_jobduty_emt);
        
        return result;
    }
    /**
    */
    
    public Map u_hire() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.u_hire(params);
        
        return result;
    }
    /**
    */
    
    public Map e_hire() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.e_hire(params);
        
        return result;
    }
    /**
    */
    
    public Map d_hire() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_hire(params);
        
        return result;
    }
    /**
    */
    
    public Map eu_person() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.eu_person(params);
        
        return result;
    }
    /**
    */
    
    public Map u_person() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.u_person(params);
        
        return result;
    }
    /**
    */
    
    public Map eu_personn() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.eu_personn(params);
        
        return result;
    }
    /**
    */
    
    public Map eu_persony() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.eu_persony(params);
        
        return result;
    }
    /**
    增加招聘信息修改
    */
    
    public Map addRecruitmentSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID = mapper.CMID(params);
        result.put("CMID", CMID);
        
        return result;
    }
    /**
    增加招聘信息修改
    */
    
    public Map addRecruitmentsSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID = mapper.CMID(params);
        result.put("CMID", CMID);
        
        return result;
    }
    /**
    修改岗位信息修改
    */
    
    public Map revisionPostSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.revisionPostSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_duty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_duty(params);
        
        return result;
    }
    /**
    */
    
    public Map d_jobduty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_jobduty(params);
        
        return result;
    }
    /**
    选择任职(岗位)要求修改
    */
    
    public Map choiceJobRequirementSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("hire_duty")){
            params=new SQLParam(request,emt.getMap());
            mapper.i(params);
        }
        
        return result;
    }
    /**
    修改任职岗位要求修改
    */
    
    public Map upJobRequirementSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.upJobRequirementSubmit(params);
        
        return result;
    }
    /**
    选择职责要求修改
    */
    
    public Map choiceResponsibilitiesSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("hire_jobduty")){
            params=new SQLParam(request,emt.getMap());
            mapper.i(params);
        }
        
        return result;
    }
    /**
    修改职责要求修改
    */
    
    public Map upResponsibilitiesSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.upResponsibilitiesSubmit(params);
        
        return result;
    }
}